The basic syntax of creating a public database link is: CREATE PUBLIC DATABASE LINK NAME.OF.DATABASE.LINK CONNECT TO schema_name IDENTIFIED BY “schema_password” USING ‘tnsnames entry’; However, many times even if you have the database permission to create a db link (CREATE DATABASE LINK system privilege), you have no access to the TNSNAMES.ORA file on the server. … Continue reading create a database link without changing the TNSNAMES.ORA